﻿USE [SampleThreeTierArchitecture]
GO

/****** Object:  StoredProcedure [dbo].[usp_UpdateBookDetails]    Script Date: 1/15/2015 7:04:11 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[usp_UpdateBookDetails] 
    @bookName nvarchar(60),
    @authorName nvarchar(60),
	@genre nvarchar(60),
	@bookId int  
AS
    update BookDetails set BookName = @bookName, AuthorName = @authorName, Genre = @genre
	where BookId = @bookId;
RETURN 0 
GO


